
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>
	
	Query Stack Overflow - Stack Exchange Data Explorer

</title><link rel="odata.service" title="StackOverflow" href="https://odata.sqlazurelabs.com/OData.svc/v0.1/rp1uiewita/StackOverflow"/>

	<link href="../App/StackExchange.DataExplorer/Content/site.css?v=1.0.3820.29455" rel="stylesheet" type="text/css" />
    <link href="../App/StackExchange.DataExplorer/Content/smoothness/jquery-ui-1.8.1.custom.css?v=1.0.3820.29455" rel="stylesheet" type="text/css" />
    <link href="../App/StackExchange.DataExplorer/Content/slickgrid/slick.grid.css?v=1.0.3820.29455" rel="stylesheet" type="text/css" />
    <link href="../App/StackExchange.DataExplorer/Content/codemirror/sqlcolors.css?v=1.0.3820.29455" rel="stylesheet" type="text/css" />
   <STYLE type="text/css">
      .post-tag{
background-color:#E0EAF1;
border-bottom:1px solid #3E6D8E;
border-right:1px solid #7F9FB6;
color:#3E6D8E;
font-size:90%;
line-height:2.4;
margin:2px 2px 2px 0;
padding:3px 4px;
text-decoration:none;
white-space:nowrap;
}
.post-tag:hover {
background-color:#3E6D8E;
border-bottom:1px solid #37607D;
border-right:1px solid #37607D;
color:#E0EAF1;
text-decoration:none;} 
   </STYLE>
</head>
<body>
  <div class="page">
    <div id="header">
      <div id="topbar">
        <div id="hlinks">
          
        <a href="/users/1">
          sam.saffron
        </a>
        <span class="link-separator">|</span>
        <a href="/account/logout">logout</a>

          <span class="link-separator">|</span> <a href="/about">about</a>
          <span class="link-separator">|</span> <a href="/faq">faq</a>
        </div>
      </div>
      <div class="clear">
      </div>
      <div id="title">
        <div id="hlogo">
          <a href="/" alt="Stack Exchange Data Explorer">
            <img src="/Content/images/see_logo.png" alt="Stack Exchange Data Explorer" width="318"
              height="91" />
          </a>
        </div>
        
<div id="hmenus">

  <div class="nav">
      <ul>
          
            <li>
              <a  href="/" title="Home">Home</a>  
            </li>
          
            <li>
              <a  href="/stackoverflow/queries" title="Queries">Queries</a>  
            </li>
          
            <li>
              <a  href="/users" title="Users">Users</a>  
            </li>
          
      </ul>
  </div>
  <div style="float: right;" class="nav">
      <ul>
          
            <li style="margin-right: 0px;">
                <a  class="youarehere"  href="/stackoverflow/query/new" title="Compose Query">Compose Query</a>
            </li>
          
      </ul>
  </div>
</div>

      </div>
      <div class="clear">
      </div>
    </div>
    
<div class="subheader"> 
    
      <h2>
          Editing Query
      </h2>
    
</div> 


    

   
    <div id="queryText">
        <div>
          <div id="queryInfo">
            <h2>Average Answerer's Age (among the tags answered by more than 1000 users with age filled)</h2>
            <p>Enter Query Description</p>
          </div>
          
<div id="aboutSite">
  <img class="site" src="http://sstatic.net/so/img/logo.png" alt="Stack Overflow" />
  <p class="tagline">
    Q&A for programmers
  </p>
</div>


          <div class="clear"></div>
        </div>
        <div class="query" style="width:70%;">
          <form id="runQueryForm" action="/query/1" method="post"> 
            <p>
              <input type="hidden" name="siteId" value="1" />
              <div id="sqlQueryWrapper" style="position:relative;">
                <textarea id="sqlQuery" name="sql" rows="18">-- Average Answerer&#39;s Age (among the tags answered by more than 1000 users with age filled)

SELECT  TagName AS Tags, AVG(Age * 1.0) AS [Average Answerer&#39;s Age], COUNT(*) AS [Number of Answerers]
FROM    (
        SELECT  DISTINCT pa.OwnerUserId, pt.TagId
        FROM    Users u
        JOIN    Posts pa
        ON      pa.OwnerUserId = U.Id
        JOIN    Posts pq
        ON      pq.Id = pa.ParentId
        JOIN    PostTags pt
        ON      pt.PostId = pq.Id
        ) ut
JOIN    Tags t
ON      t.Id = ut.TagId
JOIN    Users u
ON      u.Id = ut.OwnerUserId
WHERE   u.Age BETWEEN 10 AND 90
GROUP BY
        t.Id, t.TagName
HAVING  COUNT(*) &gt; 1000
ORDER BY
        2 DESC</textarea>
              </div>
              <div class="clear"></div>
            </p>
            <a id="schemaLink" href="#">hide schema &gt;&gt;</a>
            <div id="queryParams" style="display:none;">
              <h3>Enter Parameters</h3>
            </div>
            <p id="resultsToText">
              <input type="checkbox" name="resultsToText" value="true"/> 
              <label>Results to Text</label>
            </p>
            <p id="toolbar">
                <input type="submit" value="Run Query" />

                

                <span id="permalinks" style="display:none">
                  <a id="permalink" href="#">permalink to this query</a> 
                  <a id="saveQuery" href="#">save query</a>
                  <a id="downloadCsv" href="#" title="download results as CSV">download results</a>
                  
                      <a class="otherPermalink" href="/superuser/q//" title="View results on Super User">
                      <img src="http://sstatic.net/su/favicon.ico" alt="Super User" /></a>     
                  
                      <a class="otherPermalink" href="/serverfault/q//" title="View results on Server Fault">
                      <img src="http://sstatic.net/sf/favicon.ico" alt="Server Fault" /></a>     
                  
                      <a class="otherPermalink" href="/meta/q//" title="View results on Meta Stack Overflow">
                      <img src="http://sstatic.net/mso/favicon.ico" alt="Meta Stack Overflow" /></a>     
                  
                </span>
            </p>
          </form>
          <div class="clear"></div>
          <div id="saveDialog" style="position: relative; display: none;">
            <form id="saveQueryForm" action="#" method="post">
              <input type="hidden" name="savedQueryId" class="savedQueryId" value="48" />
              <div class="overlay">&nbsp;</div>
              <div class="dialog">
                <label>Title</label>
                <input type="text" name="title"" value="" class="title"/>
                <textarea name="description" class="description" cols="80" rows="5"></textarea>
                <div class="savePanel">
                  <input type="submit" class="save" name="saveButton" value="Save"/>
                  <input type="button" class="cancel" name="cancelButton" value="Cancel"/>
                </div>
                <p class="error ui-state-error" style="display:none"></p>
              </div>
             </form>
          </div>
         
          <div style="padding: 0pt 0.7em; display:none" class="ui-state-error ui-corner-all" id="queryErrorBox"> 
					  <p><span style="float: left; margin-right: 0.3em;" class="ui-icon ui-icon-alert"></span> 
					  <strong>Error:</strong> <span id="queryError"> </span></p>
				  </div>
          <div class="clear"></div>

        </div>
        <ul class='treeview schema' style="display:none;">
          
            <li>
              <span class="folder">Posts</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="int">PostTypeId</li>
                
                     
                  <li title="int">AcceptedAnswerId</li>
                
                     
                  <li title="datetime">CreationDate</li>
                
                     
                  <li title="int">Score</li>
                
                     
                  <li title="int">ViewCount</li>
                
                     
                  <li title="nvarchar (max)">Body</li>
                
                     
                  <li title="int">OwnerUserId</li>
                
                     
                  <li title="nvarchar (40)">OwnerDisplayName</li>
                
                     
                  <li title="int">LastEditorUserId</li>
                
                     
                  <li title="datetime">LastEditDate</li>
                
                     
                  <li title="datetime">LastActivityDate</li>
                
                     
                  <li title="nvarchar (250)">Title</li>
                
                     
                  <li title="nvarchar (150)">Tags</li>
                
                     
                  <li title="int">AnswerCount</li>
                
                     
                  <li title="int">CommentCount</li>
                
                     
                  <li title="int">FavoriteCount</li>
                
                     
                  <li title="datetime">ClosedDate</li>
                
                     
                  <li title="int">ParentId</li>
                
                     
                  <li title="datetime">CommunityOwnedDate</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">Users</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="int">Reputation</li>
                
                     
                  <li title="varchar (40)">EmailHash</li>
                
                     
                  <li title="datetime">CreationDate</li>
                
                     
                  <li title="nvarchar (40)">DisplayName</li>
                
                     
                  <li title="datetime">LastAccessDate</li>
                
                     
                  <li title="nvarchar (200)">WebsiteUrl</li>
                
                     
                  <li title="nvarchar (100)">Location</li>
                
                     
                  <li title="int">Age</li>
                
                     
                  <li title="nvarchar (max)">AboutMe</li>
                
                     
                  <li title="int">Views</li>
                
                     
                  <li title="int">UpVotes</li>
                
                     
                  <li title="int">DownVotes</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">Comments</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="int">PostId</li>
                
                     
                  <li title="int">Score</li>
                
                     
                  <li title="nvarchar (max)">Text</li>
                
                     
                  <li title="datetime">CreationDate</li>
                
                     
                  <li title="int">UserId</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">Badges</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="int">UserId</li>
                
                     
                  <li title="nvarchar (50)">Name</li>
                
                     
                  <li title="datetime">CreationDate</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">PostTags</span>
              <ul>
                
                     
                  <li title="int">PostId</li>
                
                     
                  <li title="int">TagId</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">Tags</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="varchar (255)">TagName</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">Votes</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="int">PostId</li>
                
                     
                  <li title="int">VoteTypeId</li>
                
                     
                  <li title="datetime">CreationDate</li>
                
              </ul>
            </li>
          
            <li>
              <span class="folder">VoteTypes</span>
              <ul>
                
                     
                  <li title="int">Id</li>
                
                     
                  <li title="varchar (40)">Name</li>
                
              </ul>
            </li>
          
        </ul>
        
    </div>

    <div class="clear"></div>

    <p style="display:none" class="loading"><img src="http://sstatic.net/img/progress-dots.gif"/><span>Hold tight while we fetch your results</span></p>

    <div id="queryResults" style="display:none">
      <div id="resultTabs" class="subheader">
        <div class="miniTabs">
          <a href="#grid" class="youarehere">Results</a>
          <a href="#messages">Messages</a>
        </div>
       </div>
      <div id="grid"></div> 
      <div id="messages" style="display:none; ">
        <pre><code></code></pre>
      </div> 
     
      <div id="gridStats" class= "ui-widget-header">
        <span class="duration"></span>
        <span class="rows"></span>
        <div class="clear"></div>
      </div>
    </div>

   
  <script src="../App/StackExchange.DataExplorer/Scripts/jquery-1.4.2.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/jquery.validate.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/jquery.rule.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/jquery.textarearesizer.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/jquery.event.drag-1.5.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/slick.grid.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/codemirror/codemirror.js?v=1.0.3820.29455" type="text/javascript"></script>
  <script src="../App/StackExchange.DataExplorer/Scripts/query.js?v=1.0.3820.29455" type="text/javascript"></script>

  <script type="text/javascript">

    var siteId = 1;
    var loggedOn = true;

    
var guessedUserId = 17174;


    var codemirror; 

    function getQueryInfo(text) {
      var info = {title: "", description: ""};
      var lines = text.split("\n"); 
      var gotTitle = false; 
      
      for (var i = 0; i < lines.length; i++) {
        if (lines[i].match("^--") == "--") {
          var data = lines[i].substring(2).replace(/^\s+|\s+$/g,"");
          if (gotTitle) {
            info.description += data + "\n";
          } else {
            info.title = data;
            gotTitle = true;
          }
        } else {
          break;
        }
      }
      return info;
    }


    $(document).ready(function () {
       
      $('.miniTabs').tabs();

      var textarea = $('#runQueryForm textarea');
      var treeview = $('.treeview.schema');

      var getQueryBody = function() {
        if (codemirror != null) 
        {
          return codemirror.getCode();
        } else {
          return textarea.val();
        }
      };

      $("#saveQuery").click(function() {
        
        if (!loggedOn) {
          this.href = "/account/login";
          return true;
        }

        $("#saveDialog .error").hide();
        var data = getQueryInfo(getQueryBody());
        $("#saveDialog .title").val(data.title);
        $("#saveDialog .description").val(data.description);
        $("#saveDialog").show();
        $("#saveDialog .title").focus();

        return false;
      });

       
      $("#saveQueryForm").validate({
        rules: {
          title: {
            required: true,
            minlength: 10
          }
        }
      });

      $("#saveQueryForm").submit(function() {

        if(!$(this).valid()){
          return false;
        }

        $("#saveDialog .error").hide();
        $("#saveDialog .save").attr("disabled", true);
        $.post('/saved_query/create', {
          
          queryId: current_results.queryId ,
          savedQueryId: $("#saveDialog .savedQueryId").val(),
          title: $("#saveDialog .title").val() ,
          description: $("#saveDialog .description").val(),
          siteId: siteId
        }, function(data) {
           $("#saveDialog .save").attr("disabled", false);
           if (data.success == true) {
              $("#saveDialog").hide(); 
           } else {
              $("#saveDialog .error").show().text(data.message);
           }
        });

        return false;
      });

      $("#saveDialog .cancel").click(function() {
        $("#saveDialog").hide();
        return false;
      });

      var oldTimeout = null; 

      var queryTitle = $("#queryInfo h2");
      var queryDescription = $("#queryInfo p");

      var updateTitle = function() {
        if (codemirror != null) {
          textarea.val(codemirror.getCode());
        } 
        var info = getQueryInfo(textarea.val()); 

        queryTitle.text(info.title);
        queryDescription.text(info.description);

      };

      var onTextChanged = function() {
        if (oldTimeout != null) {
          clearTimeout(oldTimeout); 
        }
        oldTimeout = setTimeout(updateTitle, 10);
      };

      if (CodeMirror.isProbablySupported()) 
      {
        codemirror = CodeMirror.fromTextArea('sqlQuery', {
          height: "250px",
          width: "100%",
          parserfile: "parsesql.js",
          stylesheet: "../App/StackExchange.DataExplorer/Content/codemirror/sqlcolors.css",
          path: "../App/StackExchange.DataExplorer/Scripts/codemirror/",
          textWrapping: false,
          tabMode: "default",
          onChange: onTextChanged,
          initCallback: function() {
            codemirror.focus();
          }
        });
      }

      $('#schemaLink').toggle(function() {
        $('.query').animate({width: "100%"}, 'fast');
        $('.schema.treeview').hide(); 
        $(this).text("<< show schema");
      }, function(){
        $('.query').animate({width: "70%"}, 'fast', function() { $('.schema.treeview').show(); });
        $(this).text("hide schema >>");
      });
      
      treeview.height(textarea.height() + 10);

      // its messy cause CodeMirror does not like the wrap method
      var queryWrapper = $('#sqlQueryWrapper');

      $('#sqlQueryWrapper').TextAreaResizer(function() { 
        treeview.height(queryWrapper.height() + 10);
        if (codemirror != null) {
          $(codemirror.wrapping).height(queryWrapper.height() - 10);
        }
      });
      
      if (codemirror == null) {
        textarea.focus();
        textarea.keydown(onTextChanged); 
      } 

      // code mirror is probably not ready yet
      ensureAllParamsEntered(textarea.val());
      populateParamsFromUrl();

      
       gotResults( {
  "resultSets": [
    {
      "columns": [
        {
          "name": "Tags",
          "type": "Text"
        },
        {
          "name": "Average Answerer's Age",
          "type": "Default"
        },
        {
          "name": "Number of Answerers",
          "type": "Number"
        }
      ],
      "rows": [
        [
          "agile",
          33.817040,
          1115
        ],
        [
          "vb6",
          33.669603,
          1135
        ],
        [
          "com",
          33.545534,
          1131
        ],
        [
          "ms-access",
          33.164041,
          1524
        ],
        [
          "business",
          33.088693,
          1026
        ],
        [
          "delphi",
          33.070296,
          1451
        ],
        [
          "software-engineering",
          32.938817,
          1471
        ],
        [
          "management",
          32.896575,
          1460
        ],
        [
          "software-development",
          32.871200,
          1250
        ],
        [
          "stored-procedures",
          32.861664,
          1706
        ],
        [
          "oracle",
          32.800000,
          2225
        ],
        [
          "tdd",
          32.799207,
          1514
        ],
        [
          "build-process",
          32.731707,
          1230
        ],
        [
          "coding-standards",
          32.677287,
          1224
        ],
        [
          "process",
          32.645186,
          1288
        ],
        [
          "sql-server-2008",
          32.633741,
          1387
        ],
        [
          "windows-services",
          32.577717,
          1113
        ],
        [
          "microsoft",
          32.557659,
          1162
        ],
        [
          "automation",
          32.553057,
          1112
        ],
        [
          "bugs",
          32.540780,
          1128
        ],
        [
          "code-review",
          32.531068,
          1207
        ],
        [
          "hardware",
          32.495878,
          1577
        ],
        [
          "tsql",
          32.450243,
          2261
        ],
        [
          "software",
          32.444180,
          1263
        ],
        [
          "assembly",
          32.412510,
          1183
        ],
        [
          "architecture",
          32.399034,
          2694
        ],
        [
          "dll",
          32.398623,
          1598
        ],
        [
          "binary",
          32.386012,
          1101
        ],
        [
          "winapi",
          32.384311,
          2027
        ],
        [
          "logging",
          32.372740,
          2047
        ],
        [
          "skills",
          32.371031,
          1008
        ],
        [
          "data",
          32.355614,
          1496
        ],
        [
          "ado.net",
          32.352619,
          1279
        ],
        [
          "asp-classic",
          32.340216,
          1017
        ],
        [
          "visual-c++",
          32.331636,
          1375
        ],
        [
          "xslt",
          32.320037,
          1053
        ],
        [
          "indexing",
          32.319664,
          1073
        ],
        [
          "project-management",
          32.315526,
          2602
        ],
        [
          "advice",
          32.304042,
          1138
        ],
        [
          "jobs",
          32.302878,
          1598
        ],
        [
          "cross-platform",
          32.279195,
          1293
        ],
        [
          "visual-studio-2005",
          32.216645,
          1574
        ],
        [
          "sql-server-2005",
          32.200585,
          2732
        ],
        [
          "comments",
          32.195299,
          1234
        ],
        [
          "ssl",
          32.160747,
          1070
        ],
        [
          "windows-vista",
          32.153648,
          1165
        ],
        [
          "garbage-collection",
          32.141608,
          1144
        ],
        [
          "testing",
          32.134468,
          2878
        ],
        [
          "delete",
          32.121687,
          1019
        ],
        [
          "application",
          32.120888,
          1125
        ],
        [
          "licensing",
          32.111197,
          1286
        ],
        [
          "configuration",
          32.102428,
          1894
        ],
        [
          "documentation",
          32.085940,
          2269
        ],
        [
          "job-interview",
          32.080251,
          1271
        ],
        [
          "resources",
          32.078493,
          1567
        ],
        [
          "development",
          32.074333,
          2287
        ],
        [
          "perl",
          32.053842,
          2303
        ],
        [
          "refactoring",
          32.029382,
          2008
        ],
        [
          "null",
          32.023200,
          1250
        ],
        [
          "career-development",
          32.017606,
          3351
        ],
        [
          "reference",
          32.014358,
          1184
        ],
        [
          "memory-management",
          32.002222,
          1800
        ],
        [
          "shell",
          32.000587,
          1701
        ],
        [
          "scripting",
          31.996786,
          1867
        ],
        [
          "wcf",
          31.981472,
          1997
        ],
        [
          "postgresql",
          31.976047,
          1336
        ],
        [
          "iis",
          31.972247,
          2162
        ],
        [
          "database-design",
          31.963538,
          2962
        ],
        [
          "excel",
          31.938756,
          2188
        ],
        [
          "concurrency",
          31.938506,
          1366
        ],
        [
          "memory",
          31.918692,
          2386
        ],
        [
          "education",
          31.917726,
          1337
        ],
        [
          "tools",
          31.911244,
          3842
        ],
        [
          "unit-testing",
          31.909068,
          3981
        ],
        [
          "operating-system",
          31.909013,
          1176
        ],
        [
          "enums",
          31.902641,
          1325
        ],
        [
          "version-control",
          31.900440,
          3857
        ],
        [
          "comparison",
          31.898750,
          1521
        ],
        [
          "data-structures",
          31.880129,
          2169
        ],
        [
          "serialization",
          31.870066,
          1647
        ],
        [
          "conversion",
          31.860465,
          1591
        ],
        [
          "books",
          31.859749,
          3508
        ],
        [
          "sharepoint",
          31.857733,
          1209
        ],
        [
          "offtopic",
          31.853425,
          2306
        ],
        [
          "compiler",
          31.852752,
          2180
        ],
        [
          "sql-server",
          31.848355,
          5836
        ],
        [
          "command-line",
          31.843720,
          2086
        ],
        [
          "casting",
          31.829845,
          1099
        ],
        [
          "deployment",
          31.823881,
          2169
        ],
        [
          "gcc",
          31.823031,
          1181
        ],
        [
          "text-editor",
          31.822612,
          1026
        ],
        [
          "memory-leaks",
          31.812030,
          1330
        ],
        [
          "threads",
          31.795542,
          1032
        ],
        [
          "debugging",
          31.791666,
          3600
        ],
        [
          "interview-questions",
          31.784927,
          2269
        ],
        [
          "interface",
          31.773044,
          1432
        ],
        [
          "not-programming-related",
          31.771117,
          2202
        ],
        [
          "source-code",
          31.770232,
          1075
        ],
        [
          "join",
          31.763651,
          1172
        ],
        [
          "exception-handling",
          31.763285,
          1656
        ],
        [
          "development-environment",
          31.759772,
          1407
        ],
        [
          "productivity",
          31.759603,
          2421
        ],
        [
          "language",
          31.755215,
          1438
        ],
        [
          "hibernate",
          31.738035,
          1191
        ],
        [
          "csv",
          31.728719,
          1257
        ],
        [
          "rest",
          31.720180,
          1333
        ],
        [
          "files",
          31.713744,
          1848
        ],
        [
          "localization",
          31.703671,
          1144
        ],
        [
          "formatting",
          31.681938,
          1506
        ],
        [
          "file-io",
          31.677685,
          1694
        ],
        [
          "unicode",
          31.674914,
          1455
        ],
        [
          "teaching",
          31.672712,
          1213
        ],
        [
          "orm",
          31.645161,
          1457
        ],
        [
          "networking",
          31.643210,
          1819
        ],
        [
          "sqlite",
          31.640977,
          1596
        ],
        [
          "self-improvement",
          31.640555,
          2017
        ],
        [
          "library",
          31.630997,
          2626
        ],
        [
          "unix",
          31.630367,
          2259
        ],
        [
          "pdf",
          31.626737,
          1870
        ],
        [
          "naming-conventions",
          31.623063,
          1743
        ],
        [
          "language-features",
          31.620689,
          1044
        ],
        [
          "efficiency",
          31.579491,
          1258
        ],
        [
          "discussion",
          31.553078,
          2647
        ],
        [
          "strings",
          31.540280,
          1353
        ],
        [
          "web-services",
          31.533670,
          3564
        ],
        [
          "console",
          31.533457,
          1076
        ],
        [
          "coding-style",
          31.529822,
          2867
        ],
        [
          "optimization",
          31.522126,
          3480
        ],
        [
          "hidden-features",
          31.521286,
          1057
        ],
        [
          ".net-3.5",
          31.509273,
          1887
        ],
        [
          "entity-framework",
          31.501285,
          1167
        ],
        [
          "properties",
          31.498767,
          1217
        ],
        [
          "visual-studio-2008",
          31.492433,
          4295
        ],
        [
          "time",
          31.489640,
          1448
        ],
        [
          "error-handling",
          31.486980,
          1421
        ],
        [
          "computer-science",
          31.484908,
          1524
        ],
        [
          "controls",
          31.483783,
          1110
        ],
        [
          "image-processing",
          31.471402,
          1084
        ],
        [
          "user-interface",
          31.468641,
          2025
        ],
        [
          "multithreading",
          31.466735,
          3848
        ],
        [
          "open-source",
          31.465813,
          2969
        ],
        [
          "sockets",
          31.460544,
          1470
        ],
        [
          "exception",
          31.459793,
          2997
        ],
        [
          "design",
          31.454788,
          4855
        ],
        [
          "graphics",
          31.453681,
          1684
        ],
        [
          "performance",
          31.441490,
          5529
        ],
        [
          "visual-studio",
          31.436777,
          5536
        ],
        [
          "functional-programming",
          31.431781,
          1246
        ],
        [
          "windows",
          31.429250,
          6947
        ],
        [
          "usability",
          31.428840,
          1061
        ],
        [
          "polls",
          31.427087,
          4718
        ],
        [
          "encryption",
          31.423144,
          1711
        ],
        [
          "web-applications",
          31.410436,
          2702
        ],
        [
          "object-oriented-design",
          31.407804,
          2614
        ],
        [
          "nhibernate",
          31.406691,
          1345
        ],
        [
          "database",
          31.406295,
          6830
        ],
        [
          "design-patterns",
          31.383238,
          3520
        ],
        [
          "static",
          31.379140,
          1419
        ],
        [
          "server",
          31.375388,
          1609
        ],
        [
          "sorting",
          31.369601,
          1783
        ],
        [
          "error",
          31.364936,
          2447
        ],
        [
          "vb.net",
          31.364052,
          4590
        ],
        [
          "stl",
          31.342541,
          1086
        ],
        [
          "language-agnostic",
          31.339293,
          6543
        ],
        [
          ".net-2.0",
          31.331521,
          1288
        ],
        [
          "parameters",
          31.328714,
          1299
        ],
        [
          "tutorials",
          31.309111,
          1734
        ],
        [
          "bash",
          31.305426,
          1935
        ],
        [
          "framework",
          31.302124,
          1271
        ],
        [
          "collections",
          31.279953,
          1711
        ],
        [
          "learning",
          31.256903,
          4780
        ],
        [
          "frameworks",
          31.243576,
          1946
        ],
        [
          "hash",
          31.230603,
          1392
        ],
        [
          "query",
          31.220041,
          2395
        ],
        [
          "encoding",
          31.211184,
          1359
        ],
        [
          "gui",
          31.208702,
          3608
        ],
        [
          "inheritance",
          31.194170,
          2230
        ],
        [
          "silverlight",
          31.180914,
          2012
        ],
        [
          "programming-languages",
          31.178907,
          3935
        ],
        [
          "pointers",
          31.158798,
          1631
        ],
        [
          "sql",
          31.154391,
          8174
        ],
        [
          "reflection",
          31.151530,
          1927
        ],
        [
          "svn",
          31.141324,
          4288
        ],
        [
          "constructor",
          31.139591,
          1225
        ],
        [
          "jsp",
          31.139344,
          1220
        ],
        [
          "osx",
          31.129666,
          2036
        ],
        [
          "fun",
          31.117544,
          2867
        ],
        [
          "cache",
          31.113163,
          1299
        ],
        [
          "math",
          31.103120,
          2628
        ],
        [
          "parsing",
          31.098615,
          2383
        ],
        [
          "c#3.0",
          31.089780,
          1047
        ],
        [
          "linq-to-sql",
          31.087456,
          2001
        ],
        [
          "datetime",
          31.084537,
          2768
        ],
        [
          "search",
          31.064340,
          2207
        ],
        [
          "subjective",
          31.057995,
          12070
        ],
        [
          "tortoisesvn",
          31.057115,
          1033
        ],
        [
          "best-practices",
          31.050015,
          9737
        ],
        [
          "plugins",
          31.049861,
          1444
        ],
        [
          "templates",
          31.029352,
          1499
        ],
        [
          "recursion",
          31.023712,
          1476
        ],
        [
          "email",
          31.018904,
          2592
        ],
        [
          "random",
          31.003961,
          1262
        ],
        [
          "mac",
          30.986486,
          2220
        ],
        [
          "security",
          30.978303,
          4609
        ],
        [
          "xml",
          30.976866,
          5706
        ],
        [
          "file",
          30.961859,
          2517
        ],
        [
          "authentication",
          30.958556,
          2051
        ],
        [
          "caching",
          30.957400,
          1385
        ],
        [
          ".net",
          30.946647,
          11321
        ],
        [
          "date",
          30.940324,
          1726
        ],
        [
          "eclipse",
          30.938931,
          2751
        ],
        [
          "update",
          30.937671,
          1091
        ],
        [
          "ide",
          30.931250,
          3360
        ],
        [
          "vim",
          30.929849,
          1397
        ],
        [
          "hosting",
          30.919563,
          1007
        ],
        [
          "databinding",
          30.906785,
          1459
        ],
        [
          "winforms",
          30.896083,
          3830
        ],
        [
          "linq",
          30.891487,
          2737
        ],
        [
          "website",
          30.883069,
          1642
        ],
        [
          "usercontrols",
          30.874641,
          1045
        ],
        [
          "loops",
          30.864908,
          1251
        ],
        [
          "oop",
          30.862096,
          3691
        ],
        [
          "api",
          30.852050,
          2609
        ],
        [
          "algorithm",
          30.849170,
          4641
        ],
        [
          "linux",
          30.837156,
          4882
        ],
        [
          "dynamic",
          30.827862,
          1371
        ],
        [
          "generics",
          30.825654,
          2214
        ],
        [
          "images",
          30.820912,
          1798
        ],
        [
          "webforms",
          30.812043,
          1096
        ],
        [
          "table",
          30.802178,
          1744
        ],
        [
          "string",
          30.796511,
          4300
        ],
        [
          "web",
          30.796428,
          3080
        ],
        [
          "events",
          30.791270,
          2314
        ],
        [
          "xcode",
          30.785039,
          1377
        ],
        [
          "syntax",
          30.777053,
          2301
        ],
        [
          "http",
          30.772255,
          2797
        ],
        [
          "string-manipulation",
          30.766022,
          2278
        ],
        [
          "cocoa",
          30.758597,
          1483
        ],
        [
          "editor",
          30.749875,
          2015
        ],
        [
          "game",
          30.740481,
          1287
        ],
        [
          "cms",
          30.734548,
          1262
        ],
        [
          "text",
          30.699308,
          1736
        ],
        [
          "functions",
          30.696881,
          1379
        ],
        [
          "ui",
          30.660440,
          1499
        ],
        [
          "validation",
          30.658714,
          2599
        ],
        [
          "video",
          30.653751,
          1213
        ],
        [
          "wpf",
          30.618846,
          2844
        ],
        [
          "c",
          30.614699,
          6286
        ],
        [
          "asp.net",
          30.610140,
          9447
        ],
        [
          "variables",
          30.576271,
          1652
        ],
        [
          "asp.net-mvc",
          30.573511,
          4047
        ],
        [
          "class",
          30.547063,
          2486
        ],
        [
          "function",
          30.546163,
          1668
        ],
        [
          "dictionary",
          30.545381,
          1245
        ],
        [
          "c++",
          30.503429,
          8311
        ],
        [
          "google",
          30.502286,
          1531
        ],
        [
          "c#",
          30.493113,
          14376
        ],
        [
          "mvc",
          30.481034,
          2900
        ],
        [
          "gridview",
          30.479582,
          1053
        ],
        [
          "web-design",
          30.455522,
          1023
        ],
        [
          "layout",
          30.444444,
          1476
        ],
        [
          "iphone-sdk",
          30.423268,
          1805
        ],
        [
          "object",
          30.419382,
          1166
        ],
        [
          "homework",
          30.397742,
          3633
        ],
        [
          "google-app-engine",
          30.391345,
          1063
        ],
        [
          "game-development",
          30.381502,
          2076
        ],
        [
          "beginner",
          30.379007,
          7174
        ],
        [
          "java",
          30.368543,
          10726
        ],
        [
          "objective-c",
          30.365091,
          2687
        ],
        [
          "url",
          30.361149,
          2193
        ],
        [
          "opengl",
          30.344357,
          1028
        ],
        [
          "select",
          30.336332,
          1445
        ],
        [
          "web-development",
          30.331155,
          6888
        ],
        [
          "git",
          30.322615,
          1835
        ],
        [
          "swing",
          30.305282,
          1117
        ],
        [
          "iphone",
          30.298053,
          4110
        ],
        [
          "flex",
          30.278750,
          1600
        ],
        [
          "browser",
          30.249146,
          2051
        ],
        [
          "cocoa-touch",
          30.242078,
          1578
        ],
        [
          "login",
          30.214355,
          1017
        ],
        [
          "session",
          30.200000,
          1900
        ],
        [
          "arrays",
          30.188107,
          4322
        ],
        [
          "android",
          30.179667,
          1564
        ],
        [
          "regex",
          30.157843,
          5119
        ],
        [
          "image",
          30.157044,
          2477
        ],
        [
          "list",
          30.143446,
          2182
        ],
        [
          "redirect",
          30.110603,
          1094
        ],
        [
          "ruby",
          30.102808,
          4095
        ],
        [
          "forms",
          30.089702,
          2185
        ],
        [
          "internet-explorer",
          30.074018,
          2675
        ],
        [
          "python",
          30.046690,
          6875
        ],
        [
          "cookies",
          30.036789,
          1196
        ],
        [
          "seo",
          29.949137,
          1101
        ],
        [
          "actionscript-3",
          29.919011,
          1457
        ],
        [
          "flash",
          29.912350,
          2510
        ],
        [
          "mysql",
          29.894548,
          7558
        ],
        [
          "json",
          29.865546,
          2499
        ],
        [
          "post",
          29.781889,
          1270
        ],
        [
          "ruby-on-rails",
          29.763744,
          3856
        ],
        [
          "apache",
          29.739515,
          2599
        ],
        [
          "ie6",
          29.643906,
          1157
        ],
        [
          "dom",
          29.636884,
          1746
        ],
        [
          "form",
          29.594704,
          1473
        ],
        [
          "django",
          29.580555,
          2160
        ],
        [
          "firefox",
          29.559006,
          2093
        ],
        [
          "html",
          29.526724,
          9018
        ],
        [
          "ajax",
          29.466346,
          4992
        ],
        [
          "javascript",
          29.429101,
          10790
        ],
        [
          "xhtml",
          29.292839,
          2025
        ],
        [
          "php",
          29.063288,
          10697
        ],
        [
          "css",
          29.056136,
          6698
        ],
        [
          "wordpress",
          28.898664,
          1273
        ],
        [
          "jquery",
          28.891976,
          7304
        ],
        [
          "jquery-ui",
          28.780530,
          1130
        ],
        [
          "php5",
          28.518057,
          1606
        ],
        [
          "div",
          28.508083,
          1299
        ]
      ],
      "messagePosition": 0
    }
  ],
  "messages": "(316 row(s) affected)\n\n",
  "url": "http://stackoverflow.com",
  "siteId": 1,
  "siteName": "stackoverflow",
  "queryId": 1920,
  "maxResults": 0,
  "firstRun": "Jun 17 2010",
  "truncated": false,
  "slug": "average-answerers-age-among-the-tags-answered-by-more-than-1000-users-with-age",
  "textOnly": false,
  "executionTime": 12383
} ); 
      

      $('.schema').show();

      $('#runQueryForm').submit(function () {

        var sql = getQueryBody();
        
        // ie hack 
        if (codemirror != null) 
        {
          textarea.val(sql);
        }

        executeQuery(sql);

        return false;
      });
    });
  </script>


    
  </div>
  <div id="footer">
    <div class="footerwrap">
      <div id="footer-menu">
        <a href="/about">about</a> | <a href="/faq">faq</a> | <a href="http://blog.stackoverflow.com/">
          blog</a> | <a href="http://itc.conversationsnetwork.org/series/stackoverflow.html">
            podcast</a> | <a href="/legal">legal</a> | <a href="http://ads.stackoverflow.com/a.aspx?ZoneID=0&amp;BannerID=323&amp;AdvertiserID=5&amp;CampaignID=194&amp;Task=Click&amp;SiteID=1">
              advertising info</a> | <b><a href="mailto:team@stackoverflow.com">contact us</a></b>
        | <b><a href="http://meta.stackoverflow.com">feedback always welcome</a></b>
        <div id="footer-sites">
          <span style="color: rgb(254, 122, 21); font-size: 140%;">■</span>&nbsp;<a href="http://stackoverflow.com">stackoverflow.com</a>&nbsp;&nbsp;
          <span style="color: rgb(254, 122, 21); font-size: 140%;">■</span>&nbsp;<a href="http://careers.stackoverflow.com">careers</a>&nbsp;&nbsp;
          <span style="color: rgb(232, 39, 44); font-size: 140%;">■</span>&nbsp;<a href="http://serverfault.com">serverfault.com</a>&nbsp;&nbsp;
          <span style="color: rgb(0, 175, 239); font-size: 140%;">■</span>&nbsp;<a href="http://superuser.com">superuser.com</a>&nbsp;&nbsp;
          <span style="color: rgb(150, 150, 150); font-size: 140%;">■</span>&nbsp;<a href="http://meta.stackoverflow.com">meta</a>&nbsp;&nbsp;
          <a href="http://www.howtogeek.com">howtogeek.com</a>&nbsp;&nbsp; <a href="http://doctype.com">
            doctype.com</a>
        </div>
      </div>
      <div id="footer-flair">
        <img src="/Content/images/windows_azure_logo.png" alt="cc-wiki, Windows Azure" usemap="#footermap"
          height="67" width="168">
        <map name="footermap">
          <area href="http://creativecommons.org/licenses/by-sa/2.5/" alt="cc-wiki" title="Creative Commons: Attribution - Share Alike"
            coords="0,0,50,67">
          <area href="http://www.microsoft.com/windowsazure/windowsazure/" alt="Windows Azure"
            title="Windows Azure" coords="62,0,168,67">
        </map>
        <div id="svnrev">
        </div>
      </div>
      <div id="copyright">
        site design and logo is © 2010 stackoverflow.com llc; user contributed content licensed
        under <a href="http://creativecommons.org/licenses/by-sa/2.5/" rel="license">cc-wiki</a>
        with <a href="http://blog.stackoverflow.com/2009/06/attribution-required/" rel="license">
          attribution required</a>
      </div>
    </div>
  </div>
</body>
</html>
